[dbo].[Meet

Property	Value
Created	3:12:33 PM Friday, January 07, 2011
Last Modified	11:40:04 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key PK_Meet_Hotel: MEETING\HOTEL_CODE$	MEETING	varchar(10)	10	('')
$Cluster Primary Key PK_Meet_Hotel: MEETING\HOTEL_CODE$	HOTEL_CODE	varchar(15)	15	('')
	ID	varchar(10)	10	('')
	COMPANY	varchar(80)	80	('')
	ADDRESS_1	varchar(40)	40	('')
	ADDRESS_2	varchar(40)	40	('')
	CITY	varchar(40)	40	('')
	STATE_PROVINCE	varchar(15)	15	('')
	ZIP	varchar(10)	10	('')
	COUNTRY	varchar(25)	25	('')
	PRIMARY_CONTACT	varchar(40)	40	('')
	TITLE	varchar(40)	40	('')
	PHONE	varchar(20)	20	('')
	FAX	varchar(20)	20	('')
	TOLL_FREE	varchar(20)	20	('')
	COMPANY_SORT	varchar(30)	30	('')
	HOTEL_CLASS	varchar(10)	10	('')
	NOTES	varchar(255)	255	('')
	ADDRESS_3	varchar(40)	40	('')
	TIME_STAMP	timestamp	8

	Name	Columns	Unique
$Cluster Primary Key PK_Meet_Hotel: MEETING\HOTEL_CODE$	PK_Meet_Hotel	MEETING, HOTEL_CODE

Type	Action	Owning Principal
Grant	Delete	IMIS
Grant	Insert	IMIS
Grant	References	IMIS
Grant	Select	IMIS
Grant	Update	IMIS

SQL Script

CREATE TABLE [dbo].[Meet_Hotel]
(
[MEETING] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_MEETING] DEFAULT (''),
[HOTEL_CODE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_HOTEL_CODE] DEFAULT (''),
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_ID] DEFAULT (''),
[COMPANY] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_COMPANY] DEFAULT (''),
[ADDRESS_1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_ADDRESS_1] DEFAULT (''),
[ADDRESS_2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_ADDRESS_2] DEFAULT (''),
[CITY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_CITY] DEFAULT (''),
[STATE_PROVINCE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_STATE_PROVINCE] DEFAULT (''),
[ZIP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_ZIP] DEFAULT (''),
[COUNTRY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_COUNTRY] DEFAULT (''),
[PRIMARY_CONTACT] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_PRIMARY_CONTACT] DEFAULT (''),
[TITLE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_TITLE] DEFAULT (''),
[PHONE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_PHONE] DEFAULT (''),
[FAX] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_FAX] DEFAULT (''),
[TOLL_FREE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_TOLL_FREE] DEFAULT (''),
[COMPANY_SORT] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_COMPANY_SORT] DEFAULT (''),
[HOTEL_CLASS] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_HOTEL_CLASS] DEFAULT (''),
[NOTES] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_NOTES] DEFAULT (''),
[ADDRESS_3] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Hotel_ADDRESS_3] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Meet_Hotel] ADD CONSTRAINT [PK_Meet_Hotel] PRIMARY KEY CLUSTERED ([MEETING], [HOTEL_CODE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Meet_Hotel] TO [IMIS]
GRANT SELECT ON  [dbo].[Meet_Hotel] TO [IMIS]
GRANT INSERT ON  [dbo].[Meet_Hotel] TO [IMIS]
GRANT DELETE ON  [dbo].[Meet_Hotel] TO [IMIS]
GRANT UPDATE ON  [dbo].[Meet_Hotel] TO [IMIS]
GO